Global Concurrency Control for Maintaining the Inter-Site Constraints in Multidatabase Systems
نویسنده
چکیده
The global inter-site constraints is to describe the integrity constraints associated with data items in diierent local databases, which specify the global connguration of the data that are considered semantically correct. Locally consistent transactions may generate global inconsistencies with the existence of global integrity constraints. Hence, we need the global transaction manager that ensure the global logical consistency, as well as the connict serializabil-ity. In this paper, we investigate the transaction model for maintaining the global integrity constraints and then propose the optimistic concurrency control method to guarantee the global serializability and logical consistency based on our transaction model.
منابع مشابه
Site-Locking Protocol for Global Concurrency Control in Multidatabase Systems
Many researches in managing global transactions in multidatabase systems(MDBS) have been proposed to solve problems of ensuring the global serializability. In these method, a few opportunities are provided to the global transaction to execute concurrently. We concentrate our attention on 1) maintaining consistent database state that is defined by global integrity constraints and 2) investigatio...
متن کاملStable Transaction Management for Preserving the Global Integrity Constraints in Multidatabase Systems
The multidatabase systems(MDBSs) are an integration of local database systems into a global distributed database system. The objectives of global transaction management are to avoid the inconsistent retrievals and to guarantee the global serializability under the existence of indirect conflict which is unknown to the global transaction manager(GTM). Many researches have shown that it is difficu...
متن کاملOptimistic Concurrency Control for Maintaining the Global Integrity Constraint in MDBSs
The multidatabase system(MDBS) has a global database, a set of global and local transactions, and a global transaction manager(GTM) which is built on top of a number of pre-existing database management systems(DBMS) that are being integrated into a single MDBS. The global transaction manager has the responsibility for maintaining the global consistency of MDBS. It is impossible for LDBSs to pre...
متن کاملAchieving High Degree of Concurrency in Multidatabase Transaction Scheduling
A multidatabase system (MDBS), which is also called a heterogeneous distributed database system (HDDBS) or federated database system (FDBS), is a facility that allows users or applications to access data located in multiple local database systems (LDBSs), each of which is autonomously operated. Several practical MDBS concurrency control schemes have been proposed whilst maintaining global consi...
متن کاملTransaction scheduling in dynamic composite multidatabase systems
This paper proposes composite multidatabase architecture consisting of multiple, possibly heterogeneous, peer multidatabase servers distributed on a communications network. The domain of each multidatabase server is treated as a multidatabase cell. Global transactions could span multiple multidatabase cells, sometimes forcing multidatabase servers to act as component database systems. Although ...
متن کامل